IF exists(SELECT * FROM dbo.sysobjects WHERE name='vulFietsvergoeding' AND xtype='P') 
BEGIN
	DROP PROCEDURE vulFietsvergoeding
END
GO

CREATE  PROCEDURE vulFietsvergoeding
as
insert fietsvergoeding(naamcode)
select a.naamcode 
from administratie as a
	left join fietsvergoeding as f
	  on a.naamcode = f.naamcode
where f.naamcode is null